Punished Portfolio Profiling Report

Dataset statistics

Number of variables	50
Number of observations	48982
Missing cells	388519
Missing cells (%)	15.9%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	18.7 MiB
Average record size in memory	400.0 B

Variable types

CAT	32
NUM	18

Warnings

`FECHAENTRADA` has a high cardinality: 494 distinct values	High cardinality
`FECHASALIDA` has a high cardinality: 426 distinct values	High cardinality
`FECHAACTUALIZACION` has a high cardinality: 395 distinct values	High cardinality
`FECHAMORADESDE` has a high cardinality: 1921 distinct values	High cardinality
`FECHAMOVIMIENTO` has a high cardinality: 517 distinct values	High cardinality
`VCTO_CUOTA1` has a high cardinality: 954 distinct values	High cardinality
`FECHA_VCTO` has a high cardinality: 2047 distinct values	High cardinality
`FECHAULTPAGO` has a high cardinality: 1130 distinct values	High cardinality
`MUNICRESIDENCIA` has a high cardinality: 824 distinct values	High cardinality
`IES` has a high cardinality: 297 distinct values	High cardinality
`NOMBREPROGRAMA` has a high cardinality: 2279 distinct values	High cardinality
`SUBLINEA` has a high cardinality: 74 distinct values	High cardinality
`FECHA_ACUERDO` has a high cardinality: 1423 distinct values	High cardinality
`fecha Venc Cuota Vigente` has a high cardinality: 103 distinct values	High cardinality
`Valor Cuota Vigente` has a high cardinality: 6843 distinct values	High cardinality
`RazonSocial` has a high cardinality: 19241 distinct values	High cardinality
`UltimoPeriodoCotizado` has a high cardinality: 174 distinct values	High cardinality
`Tipificacion` has a high cardinality: 92 distinct values	High cardinality
`SALDOCAPITALACIERRE` is highly correlated with `SALDOTOTAL_ACT` and 1 other fields	High correlation
`SALDOTOTAL_ACT` is highly correlated with `SALDOCAPITALACIERRE` and 1 other fields	High correlation
`CAPITALICETEX_ACT` is highly correlated with `SALDOTOTAL_ACT` and 1 other fields	High correlation
`SUBLINEA` is highly correlated with `LINEA`	High correlation
`LINEA` is highly correlated with `SUBLINEA`	High correlation
`FECHASALIDA` has 37376 (76.3%) missing values	Missing
`FECHAMORADESDE` has 6955 (14.2%) missing values	Missing
`NROCUOTASMORA` has 651 (1.3%) missing values	Missing
`CALIFICACIONACTUAL` has 2592 (5.3%) missing values	Missing
`VCTO_CUOTA1` has 1034 (2.1%) missing values	Missing
`FECHA_VCTO` has 990 (2.0%) missing values	Missing
`FECHAULTPAGO` has 28842 (58.9%) missing values	Missing
`IES` has 1136 (2.3%) missing values	Missing
`NOMBREPROGRAMA` has 1148 (2.3%) missing values	Missing
`ESTADOACTUAL` has 2909 (5.9%) missing values	Missing
`ESTRATO` has 3002 (6.1%) missing values	Missing
`SEXO` has 3123 (6.4%) missing values	Missing
`ESTADOCIVIL` has 2964 (6.1%) missing values	Missing
`Rangodiasmora` has 12305 (25.1%) missing values	Missing
`CONCEPTO` has 14625 (29.9%) missing values	Missing
`FECHA_ACUERDO` has 15306 (31.2%) missing values	Missing
`ESTADO_ACUERDO` has 15306 (31.2%) missing values	Missing
`TIPO_ACUERDO` has 15306 (31.2%) missing values	Missing
`CUOTAS_PAGADAS_ACUERDO` has 23473 (47.9%) missing values	Missing
`CUOTAS_MORA_ACUERDO` has 23473 (47.9%) missing values	Missing
`CUOTAS_FUTURAS_ACUERDO` has 23473 (47.9%) missing values	Missing
`fecha Venc Cuota Vigente` has 33410 (68.2%) missing values	Missing
`Valor Cuota Vigente` has 15306 (31.2%) missing values	Missing
`No. ACUERDOS DE PAGO` has 15306 (31.2%) missing values	Missing
`RazonSocial` has 17908 (36.6%) missing values	Missing
`UltimoPeriodoCotizado` has 14172 (28.9%) missing values	Missing
`FechaFosyga` has 14172 (28.9%) missing values	Missing
`Hora_ContactoEfectivo` has 20802 (42.5%) missing values	Missing
`Llamadas_recibidas` has 11236 (22.9%) missing values	Missing
`Llamadas_realizadas` has 3240 (6.6%) missing values	Missing
`Tipificacion` has 2524 (5.2%) missing values	Missing
`VALORCUOTA` is highly skewed (γ1 = 33.51314313)	Skewed
`CUOTAS_FUTURAS_ACUERDO` is highly skewed (γ1 = 21.17064286)	Skewed
`IDSOLICITUD` has unique values	Unique
`NROCUOTASMORA` has 5602 (11.4%) zeros	Zeros
`NUMDIASMORA_ACT` has 8733 (17.8%) zeros	Zeros
`VALORCUOTA` has 786 (1.6%) zeros	Zeros
`SALDOTOTALMORA1_ACT` has 8418 (17.2%) zeros	Zeros
`SALDOTOTAL_ACT` has 2105 (4.3%) zeros	Zeros
`CODSNIES_INST` has 828 (1.7%) zeros	Zeros
`CAPITALICETEX_ACT` has 3863 (7.9%) zeros	Zeros
`CUOTAS_PAGADAS_ACUERDO` has 14348 (29.3%) zeros	Zeros
`CUOTAS_MORA_ACUERDO` has 12558 (25.6%) zeros	Zeros
`CUOTAS_FUTURAS_ACUERDO` has 25087 (51.2%) zeros	Zeros

Reproduction

Analysis started	2020-12-01 20:03:18.791605
Analysis finished	2020-12-01 20:04:47.377204
Duration	1 minute and 28.59 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

IDSOLICITUD
Real number (ℝ_≥0)

UNIQUE

Distinct	48982
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1511724.602
Minimum	23
Maximum	3934204
Zeros	0
Zeros (%)	0.0%
Memory size	382.7 KiB

Quantile statistics

Minimum	23
5-th percentile	79240.8
Q1	432336
median	1609889
Q3	2309858.25
95-th percentile	3091331.55
Maximum	3934204
Range	3934181
Interquartile range (IQR)	1877522.25

Descriptive statistics

Standard deviation	987382.5691
Coefficient of variation (CV)	0.6531497655
Kurtosis	-1.103970038
Mean	1511724.602
Median Absolute Deviation (MAD)	914245.5
Skewness	0.04443426226
Sum	7.404729444e+10
Variance	9.749243378e+11
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3475455	1	< 0.1%
2977159	1	< 0.1%
1701268	1	< 0.1%
3067283	1	< 0.1%
1546447	1	< 0.1%
412413	1	< 0.1%
273807	1	< 0.1%
1785229	1	< 0.1%
69003	1	< 0.1%
2629001	1	< 0.1%
Other values (48972)	48972	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
23	1	< 0.1%
39	1	< 0.1%
47	1	< 0.1%
60	1	< 0.1%
68	1	< 0.1%

Value	Count	Frequency (%)
3934204	1	< 0.1%
3897316	1	< 0.1%
3863349	1	< 0.1%
3828530	1	< 0.1%
3828315	1	< 0.1%

FECHAENTRADA
Categorical

HIGH CARDINALITY

Distinct	494
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	382.7 KiB

2019-11-13	16752
2020-07-07	10140
2020-09-08	1873
2020-09-22	1534
2020-06-24	1508
Other values (489)	17175

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2019-11-13	16752	34.2%
2020-07-07	10140	20.7%
2020-09-08	1873	3.8%
2020-09-22	1534	3.1%
2020-06-24	1508	3.1%
2018-11-01	1213	2.5%
2020-08-18	1115	2.3%
2020-02-26	1093	2.2%
2020-11-10	786	1.6%
2020-11-01	718	1.5%
Other values (484)	12250	25.0%

Frequencies of value counts

Unique

Unique	133 ?
Unique (%)	0.3%

Histogram of lengths of the category

Length

Max length	10
Median length	10
Mean length	10
Min length	10

FECHASALIDA
Categorical

HIGH CARDINALITY
MISSING

Distinct	426
Distinct (%)	3.7%
Missing	37376
Missing (%)	76.3%
Memory size	382.7 KiB

2020-08-19	1035
2019-04-04	300
2020-11-10	228
2020-10-16	214
2019-11-12	160
Other values (421)	9669

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2020-08-19	1035	2.1%
2019-04-04	300	0.6%
2020-11-10	228	0.5%
2020-10-16	214	0.4%
2019-11-12	160	0.3%
2020-09-23	139	0.3%
2019-01-15	131	0.3%
2020-10-08	129	0.3%
2019-05-07	117	0.2%
2020-11-11	117	0.2%
Other values (416)	9036	18.4%
(Missing)	37376	76.3%

Frequencies of value counts

Unique

Unique	33 ?
Unique (%)	0.3%

Histogram of lengths of the category

Length

Max length	10
Median length	3
Mean length	4.658609285
Min length	3

FECHAACTUALIZACION
Categorical

HIGH CARDINALITY

Distinct	395
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Memory size	382.7 KiB

2019-11-13	14471
2020-07-07	9633
2020-09-08	1863
2020-09-22	1538
2020-06-24	1460
Other values (390)	20017

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2019-11-13	14471	29.5%
2020-07-07	9633	19.7%
2020-09-08	1863	3.8%
2020-09-22	1538	3.1%
2020-06-24	1460	3.0%
2020-02-26	1111	2.3%
2020-08-19	1047	2.1%
2020-11-10	894	1.8%
2020-07-03	659	1.3%
2019-04-04	311	0.6%
Other values (385)	15995	32.7%

Frequencies of value counts

Unique

Unique	5 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	10
Median length	10
Mean length	10
Min length	10

FECHAMORADESDE
Categorical

HIGH CARDINALITY
MISSING

Distinct	1921
Distinct (%)	4.6%
Missing	6955
Missing (%)	14.2%
Memory size	382.7 KiB

2019-01-05	2595
2017-07-05	1111
2019-05-05	953
2018-11-05	876
2019-02-05	870
Other values (1916)	35622

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2019-01-05	2595	5.3%
2017-07-05	1111	2.3%
2019-05-05	953	1.9%
2018-11-05	876	1.8%
2019-02-05	870	1.8%
2018-02-05	813	1.7%
2017-01-20	744	1.5%
2019-04-05	658	1.3%
2019-03-20	547	1.1%
2018-08-05	534	1.1%
Other values (1911)	32326	66.0%
(Missing)	6955	14.2%

Frequencies of value counts

Unique

Unique	752 ?
Unique (%)	1.8%

Histogram of lengths of the category

Length

Max length	10
Median length	10
Mean length	9.006063452
Min length	3

NROCUOTASMORA
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	91
Distinct (%)	0.2%
Missing	651
Missing (%)	1.3%
Infinite	0
Infinite (%)	0.0%

Mean	14.73381474
Minimum	0
Maximum	124
Zeros	5602
Zeros (%)	11.4%
Memory size	382.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	13
Q3	21
95-th percentile	47
Maximum	124
Range	124
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	14.54075128
Coefficient of variation (CV)	0.9868965734
Kurtosis	1.085486307
Mean	14.73381474
Median Absolute Deviation (MAD)	11
Skewness	1.139595524
Sum	712100
Variance	211.4334477
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	8789	17.9%
0	5602	11.4%
17	3001	6.1%
12	2424	4.9%
55	1603	3.3%
24	1540	3.1%
14	1442	2.9%
20	1404	2.9%
16	1393	2.8%
18	1361	2.8%
Other values (81)	19772	40.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	5602	11.4%
1	8789	17.9%
2	1087	2.2%
3	825	1.7%
4	799	1.6%

Value	Count	Frequency (%)
124	1	< 0.1%
118	1	< 0.1%
110	1	< 0.1%
108	1	< 0.1%
107	1	< 0.1%

NUMDIASMORA_ACT
Real number (ℝ_≥0)

ZEROS

Distinct	2791
Distinct (%)	5.7%
Missing	74
Missing (%)	0.2%
Infinite	0
Infinite (%)	0.0%

Mean	699.8280445
Minimum	0
Maximum	7105
Zeros	8733
Zeros (%)	17.8%
Memory size	382.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	5
median	548
Q3	1003
95-th percentile	2428
Maximum	7105
Range	7105
Interquartile range (IQR)	998

Descriptive statistics

Standard deviation	808.4130065
Coefficient of variation (CV)	1.155159489
Kurtosis	4.28414568
Mean	699.8280445
Median Absolute Deviation (MAD)	522
Skewness	1.890921665
Sum	34227190
Variance	653531.5891
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8733	17.8%
4	2847	5.8%
548	2281	4.7%
428	763	1.6%
5	714	1.5%
517	706	1.4%
6	660	1.3%
1027	639	1.3%
645	631	1.3%
609	552	1.1%
Other values (2781)	30382	62.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	8733	17.8%
1	45	0.1%
2	38	0.1%
3	32	0.1%
4	2847	5.8%

Value	Count	Frequency (%)
7105	1	< 0.1%
5796	2	< 0.1%
5765	1	< 0.1%
5583	1	< 0.1%
5467	1	< 0.1%

VALORCUOTA
Real number (ℝ)

SKEWED
ZEROS

Distinct	46532
Distinct (%)	95.6%
Missing	319
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%

Mean	229429.5811
Minimum	-222527.42
Maximum	38757829
Zeros	786
Zeros (%)	1.6%
Memory size	382.7 KiB

Quantile statistics

Minimum	-222527.42
5-th percentile	23082.654
Q1	95207.5
median	164259.85
Q3	268769.5
95-th percentile	583414.8
Maximum	38757829
Range	38980356.42
Interquartile range (IQR)	173562

Descriptive statistics

Standard deviation	456157.3658
Coefficient of variation (CV)	1.988223853
Kurtosis	1881.28009
Mean	229429.5811
Median Absolute Deviation (MAD)	81033.4
Skewness	33.51314313
Sum	1.116473171e+10
Variance	2.080795424e+11
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	786	1.6%
82543	17	< 0.1%
880	10	< 0.1%
87881	8	< 0.1%
82817	8	< 0.1%
115037	8	< 0.1%
54972	8	< 0.1%
105807	8	< 0.1%
100895	7	< 0.1%
113763	7	< 0.1%
Other values (46522)	47796	97.6%
(Missing)	319	0.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-222527.42	1	< 0.1%
-68484.1	1	< 0.1%
-3160.87	1	< 0.1%
0	786	1.6%
0.11	1	< 0.1%

Value	Count	Frequency (%)
38757829	1	< 0.1%
26795164	1	< 0.1%
24508615	1	< 0.1%
22408113.99	1	< 0.1%
18446118	1	< 0.1%

SALDOTOTALMORA1_ACT
Real number (ℝ_≥0)

ZEROS

Distinct	39887
Distinct (%)	82.0%
Missing	319
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%

Mean	4326886.624
Minimum	0
Maximum	95345584.28
Zeros	8418
Zeros (%)	17.2%
Memory size	382.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	199752.28
median	2409915.18
Q3	5676536.385
95-th percentile	15463038.59
Maximum	95345584.28
Range	95345584.28
Interquartile range (IQR)	5476784.105

Descriptive statistics

Standard deviation	6327928.17
Coefficient of variation (CV)	1.462466831
Kurtosis	20.96088343
Mean	4326886.624
Median Absolute Deviation (MAD)	2359520.66
Skewness	3.605394993
Sum	2.105592838e+11
Variance	4.004267493e+13
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	8418	17.2%
1604594.17	17	< 0.1%
4460496.48	7	< 0.1%
5385244.59	7	< 0.1%
1966423.68	7	< 0.1%
1406082.31	6	< 0.1%
2073324.43	6	< 0.1%
1638433.44	6	< 0.1%
3090958.6	5	< 0.1%
1338213.81	5	< 0.1%
Other values (39877)	40179	82.0%
(Missing)	319	0.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	8418	17.2%
1.01	1	< 0.1%
1.04	1	< 0.1%
1.1	1	< 0.1%
1.11	1	< 0.1%

Value	Count	Frequency (%)
95345584.28	1	< 0.1%
89503374.45	1	< 0.1%
83325425.36	1	< 0.1%
79976431.75	1	< 0.1%
78854847.89	1	< 0.1%

SALDOTOTAL_ACT
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	46021
Distinct (%)	94.6%
Missing	319
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%

Mean	8411400.313
Minimum	-19509915.75
Maximum	113877907.3
Zeros	2105
Zeros (%)	4.3%
Memory size	382.7 KiB

Quantile statistics

Minimum	-19509915.75
5-th percentile	0
Q1	2169046.955
median	5613834.84
Q3	11188705.32
95-th percentile	26796530.29
Maximum	113877907.3
Range	133387823
Interquartile range (IQR)	9019658.365

Descriptive statistics

Standard deviation	9615150.287
Coefficient of variation (CV)	1.143109343
Kurtosis	10.72306396
Mean	8411400.313
Median Absolute Deviation (MAD)	4041702.68
Skewness	2.6270489
Sum	4.093239734e+11
Variance	9.245111504e+13
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2105	4.3%
1	22	< 0.1%
1604594.17	17	< 0.1%
-34	10	< 0.1%
-15	9	< 0.1%
-7	9	< 0.1%
-31	9	< 0.1%
-43	9	< 0.1%
-5	8	< 0.1%
-18	8	< 0.1%
Other values (46011)	46457	94.8%
(Missing)	319	0.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-19509915.75	1	< 0.1%
-13755959.58	1	< 0.1%
-12416641.13	1	< 0.1%
-10200329.15	1	< 0.1%
-8913752.49	1	< 0.1%

Value	Count	Frequency (%)
113877907.3	1	< 0.1%
106794779.3	1	< 0.1%
103620867.8	1	< 0.1%
102902115.2	1	< 0.1%
100504771.6	1	< 0.1%

FECHAMOVIMIENTO
Categorical

HIGH CARDINALITY

Distinct	517
Distinct (%)	1.1%
Missing	74
Missing (%)	0.2%
Memory size	382.7 KiB

2019-11-13	14480
2020-07-07	9633
2020-09-08	1863
2020-09-22	1538
2020-06-24	1460
Other values (512)	19934

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2019-11-13	14480	29.6%
2020-07-07	9633	19.7%
2020-09-08	1863	3.8%
2020-09-22	1538	3.1%
2020-06-24	1460	3.0%
2020-02-26	1111	2.3%
2020-08-19	1047	2.1%
2020-11-10	894	1.8%
2020-07-03	659	1.3%
2019-04-04	311	0.6%
Other values (507)	15912	32.5%

Frequencies of value counts

Unique

Unique	89 ?
Unique (%)	0.2%

Histogram of lengths of the category

Length

Max length	10
Median length	10
Mean length	9.989424687
Min length	3

CALIFICACIONACTUAL
Categorical

MISSING

Distinct	7
Distinct (%)	< 0.1%
Missing	2592
Missing (%)	5.3%
Memory size	382.7 KiB

K	36696
E	9499
DD	78
D	74
K	41
Other values (2)	2

Frequencies
Length

Value	Count	Frequency (%)
K	36696	74.9%
E	9499	19.4%
DD	78	0.2%
D	74	0.2%
K	41	0.1%
BB	1	< 0.1%
AA	1	< 0.1%
(Missing)	2592	5.3%

Frequencies of value counts

Unique

Unique	2 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	5
Median length	1
Mean length	1.110816218
Min length	1

VCTO_CUOTA1
Categorical

HIGH CARDINALITY
MISSING

Distinct	954
Distinct (%)	2.0%
Missing	1034
Missing (%)	2.1%
Memory size	382.7 KiB

2019-01-05	2680
2018-12-05	2420
2015-12-17	1784
2017-07-05	1657
2011-07-02	1352
Other values (949)	38055

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2019-01-05	2680	5.5%
2018-12-05	2420	4.9%
2015-12-17	1784	3.6%
2017-07-05	1657	3.4%
2011-07-02	1352	2.8%
2014-08-17	1266	2.6%
2018-02-05	1211	2.5%
2017-01-20	1172	2.4%
2016-12-20	1141	2.3%
2013-02-05	1130	2.3%
Other values (944)	32135	65.6%

Frequencies of value counts

Unique

Unique	421 ?
Unique (%)	0.9%

Histogram of lengths of the category

Length

Max length	10
Median length	10
Mean length	9.852231432
Min length	3

FECHA_VCTO
Categorical

HIGH CARDINALITY
MISSING

Distinct	2047
Distinct (%)	4.3%
Missing	990
Missing (%)	2.0%
Memory size	382.7 KiB

2024-12-05	912
2018-06-05	613
2020-12-05	487
2022-12-05	471
2018-12-20	423
Other values (2042)	45086

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2024-12-05	912	1.9%
2018-06-05	613	1.3%
2020-12-05	487	1.0%
2022-12-05	471	1.0%
2018-12-20	423	0.9%
2021-12-05	396	0.8%
2019-06-05	381	0.8%
2020-10-05	372	0.8%
2020-07-17	368	0.8%
2020-12-20	349	0.7%
Other values (2037)	43220	88.2%
(Missing)	990	2.0%

Frequencies of value counts

Unique

Unique	739 ?
Unique (%)	1.5%

Histogram of lengths of the category

Length

Max length	10
Median length	10
Mean length	9.858519456
Min length	3

FECHAULTPAGO
Categorical

HIGH CARDINALITY
MISSING

Distinct	1130
Distinct (%)	5.6%
Missing	28842
Missing (%)	58.9%
Memory size	382.7 KiB

2018-10-30	475
2019-02-28	350
2019-09-30	192
2020-09-22	189
2020-08-31	163
Other values (1125)	18771

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2018-10-30	475	1.0%
2019-02-28	350	0.7%
2019-09-30	192	0.4%
2020-09-22	189	0.4%
2020-08-31	163	0.3%
2019-08-30	160	0.3%
2020-09-21	145	0.3%
2020-07-31	144	0.3%
2020-09-30	124	0.3%
2020-02-28	118	0.2%
Other values (1120)	18080	36.9%
(Missing)	28842	58.9%

Frequencies of value counts

Unique

Unique	383 ?
Unique (%)	1.9%

Histogram of lengths of the category

Length

Max length	10
Median length	3
Mean length	5.878200155
Min length	3

SALDOINICIAAMORT
Real number (ℝ_≥0)

Distinct	47896
Distinct (%)	98.5%
Missing	333
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%

Mean	9538704.363
Minimum	0
Maximum	94723156
Zeros	36
Zeros (%)	0.1%
Memory size	382.7 KiB

Quantile statistics

Minimum	0
5-th percentile	954666.42
Q1	3414070.93
median	6896904.01
Q3	12806253
95-th percentile	26243843.99
Maximum	94723156
Range	94723156
Interquartile range (IQR)	9392182.07

Descriptive statistics

Standard deviation	9049199.759
Coefficient of variation (CV)	0.9486822754
Kurtosis	9.015672172
Mean	9538704.363
Median Absolute Deviation (MAD)	4235939.48
Skewness	2.373503809
Sum	4.640484286e+11
Variance	8.188801628e+13
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	36	0.1%
1631753.35	22	< 0.1%
314883.18	20	< 0.1%
1732250	18	< 0.1%
1710663.5	14	< 0.1%
316713.09	8	< 0.1%
2042970.97	8	< 0.1%
1119038.58	7	< 0.1%
1667732.3	7	< 0.1%
1247809.59	7	< 0.1%
Other values (47886)	48502	99.0%
(Missing)	333	0.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	36	0.1%
1038.17	1	< 0.1%
1179.08	1	< 0.1%
2318.5	1	< 0.1%
3658	1	< 0.1%

Value	Count	Frequency (%)
94723156	1	< 0.1%
93503758.89	1	< 0.1%
88872006.58	1	< 0.1%
87144402.49	1	< 0.1%
86573797	1	< 0.1%

DEPTORESIDENCIA
Categorical

Distinct	36
Distinct (%)	0.1%
Missing	354
Missing (%)	0.7%
Memory size	382.7 KiB

DISTRITO CAPITAL	8651
ATLANTICO	7025
BOLIVAR	6616
VALLE DEL CAUCA	3419
ANTIOQUIA	2612
Other values (31)	20305

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
DISTRITO CAPITAL	8651	17.7%
ATLANTICO	7025	14.3%
BOLIVAR	6616	13.5%
VALLE DEL CAUCA	3419	7.0%
ANTIOQUIA	2612	5.3%
SUCRE	2291	4.7%
SANTANDER	2183	4.5%
CORDOBA	2090	4.3%
CUNDINAMARCA	1768	3.6%
MAGDALENA	1119	2.3%
Other values (26)	10854	22.2%

Frequencies of value counts

Unique

Unique	4 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	18
Median length	9
Mean length	9.852292679
Min length	3

MUNICRESIDENCIA
Categorical

HIGH CARDINALITY

Distinct	824
Distinct (%)	1.7%
Missing	357
Missing (%)	0.7%
Memory size	382.7 KiB

BOGOTA D.C.	8468
CARTAGENA	5766
BARRANQUILLA	5070
CALI	2357
MEDELLIN	1436
Other values (819)	25528

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
BOGOTA D.C.	8468	17.3%
CARTAGENA	5766	11.8%
BARRANQUILLA	5070	10.4%
CALI	2357	4.8%
MEDELLIN	1436	2.9%
SINCELEJO	1363	2.8%
SOLEDAD	1142	2.3%
BUCARAMANGA	988	2.0%
MONTERIA	729	1.5%
CUCUTA	665	1.4%
Other values (814)	20641	42.1%

Frequencies of value counts

Unique

Unique	163 ?
Unique (%)	0.3%

Histogram of lengths of the category

Length

Max length	25
Median length	9
Mean length	9.046853946
Min length	1

CODSNIES_INST
Real number (ℝ_≥0)

ZEROS

Distinct	306
Distinct (%)	0.6%
Missing	320
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%

Mean	2532.688422
Minimum	0
Maximum	9907
Zeros	828
Zeros (%)	1.7%
Memory size	382.7 KiB

Quantile statistics

Minimum	0
5-th percentile	1114.05
Q1	1729
median	1832
Q3	2832
95-th percentile	4813
Maximum	9907
Range	9907
Interquartile range (IQR)	1103

Descriptive statistics

Standard deviation	1518.676917
Coefficient of variation (CV)	0.5996303784
Kurtosis	8.413529948
Mean	2532.688422
Median Absolute Deviation (MAD)	715
Skewness	2.482437179
Sum	123245684
Variance	2306379.578
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3710	2502	5.1%
1832	1699	3.5%
2102	1360	2.8%
2805	1221	2.5%
1804	1175	2.4%
2823	1148	2.3%
2836	1100	2.2%
4813	993	2.0%
1805	950	1.9%
1818	930	1.9%
Other values (296)	35584	72.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	828	1.7%
2	329	0.7%
1101	149	0.3%
1102	76	0.2%
1103	47	0.1%

Value	Count	Frequency (%)
9907	22	< 0.1%
9906	9	< 0.1%
9905	15	< 0.1%
9904	2	< 0.1%
9903	1	< 0.1%

IES
Categorical

HIGH CARDINALITY
MISSING

Distinct	297
Distinct (%)	0.6%
Missing	1136
Missing (%)	2.3%
Memory size	382.7 KiB

FUNDACION TECNOLOGICA ANTONIO DE AREVALO	2500
UNIVERSIDAD TECNOLOGICA DE BOLIVAR	1699
UNIVERSIDAD COOPERATIVA DE COLOMBIA	1598
UNIVERSIDAD NACIONAL ABIERTA Y A DISTANCIA UNAD	1360
UNIVERSIDAD SIMON BOLIVAR	1221
Other values (292)	39468

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
FUNDACION TECNOLOGICA ANTONIO DE AREVALO	2500	5.1%
UNIVERSIDAD TECNOLOGICA DE BOLIVAR	1699	3.5%
UNIVERSIDAD COOPERATIVA DE COLOMBIA	1598	3.3%
UNIVERSIDAD NACIONAL ABIERTA Y A DISTANCIA UNAD	1360	2.8%
UNIVERSIDAD SIMON BOLIVAR	1221	2.5%
UNIVERSIDAD LIBRE	1182	2.4%
PA FIDUPREVISORAS A UNIVERSIDAD AUTONOMA DEL CARIBE	1175	2.4%
CORPORACION UNIVERSITARIA DEL CARIBE	1148	2.3%
CORPORACION UNIVERSITARIA EMPRESARIAL DE SALAMANCA	1100	2.2%
CORPORACION UNIFICADA NACIONAL DE EDUCACION SUPERI	993	2.0%
Other values (287)	33870	69.1%
(Missing)	1136	2.3%

Frequencies of value counts

Unique

Unique	27 ?
Unique (%)	0.1%

Histogram of lengths of the category

Length

Max length	80
Median length	35
Mean length	34.69554122
Min length	3

NOMBREPROGRAMA
Categorical

HIGH CARDINALITY
MISSING

Distinct	2279
Distinct (%)	4.8%
Missing	1148
Missing (%)	2.3%
Memory size	382.7 KiB

DERECHO	4326
CONTADURIA PUBLICA	2300
PSICOLOGIA	2299
ADMINISTRACION DE EMPRESAS	1897
MEDICINA	1821
Other values (2274)	35191

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
DERECHO	4326	8.8%
CONTADURIA PUBLICA	2300	4.7%
PSICOLOGIA	2299	4.7%
ADMINISTRACION DE EMPRESAS	1897	3.9%
MEDICINA	1821	3.7%
INGENIERIA INDUSTRIAL	1666	3.4%
INGENIERIA DE SISTEMAS	1191	2.4%
TECNOLOGIA EN SALUD OCUPACIONAL	1110	2.3%
INGENIERIA CIVIL	1046	2.1%
ENFERMERIA	931	1.9%
Other values (2269)	29247	59.7%
(Missing)	1148	2.3%

Frequencies of value counts

Unique

Unique	898 ?
Unique (%)	1.9%

Histogram of lengths of the category

Length

Max length	100
Median length	22
Mean length	25.23867951
Min length	3

NIVELDEFORMACION
Categorical

Distinct	14
Distinct (%)	< 0.1%
Missing	335
Missing (%)	0.7%
Memory size	382.7 KiB

UNIVERSITARIA	34155
TECNOLOGICA TERMINAL	10318
TECNICA PROFESIONAL	2311
ESPECIALIZACION	826
MAESTRIA	642
Other values (9)	395

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
UNIVERSITARIA	34155	69.7%
TECNOLOGICA TERMINAL	10318	21.1%
TECNICA PROFESIONAL	2311	4.7%
ESPECIALIZACION	826	1.7%
MAESTRIA	642	1.3%
EDUCACION CONTINUADA	329	0.7%
TECNOLOGICA	26	0.1%
DOCTORADO	22	< 0.1%
ESPECIALIZACION UNIVERSITARIA	5	< 0.1%
ESPECIALIZACION TECNOLOGICA	4	< 0.1%
Other values (4)	9	< 0.1%
(Missing)	335	0.7%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	33
Median length	13
Mean length	14.70660651
Min length	3

LINEA
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	319
Missing (%)	0.7%
Memory size	382.7 KiB

ACCES	33891
LINEAS TRADICIONALES	14772

Frequencies
Length

Value	Count	Frequency (%)
ACCES	33891	69.2%
LINEAS TRADICIONALES	14772	30.2%
(Missing)	319	0.7%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	20
Median length	5
Mean length	9.510677392
Min length	3

TIPOCARTERA
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	319
Missing (%)	0.7%
Memory size	382.7 KiB

AMORTIZACION	48662
ESTUDIOS	1

Frequencies
Length

Value	Count	Frequency (%)
AMORTIZACION	48662	99.3%
ESTUDIOS	1	< 0.1%
(Missing)	319	0.7%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	12
Median length	12
Mean length	11.94130497
Min length	3

ESTADOACTUAL
Categorical

MISSING

Distinct	21
Distinct (%)	< 0.1%
Missing	2909
Missing (%)	5.9%
Memory size	382.7 KiB

COBRO PREJURIDICO - INGRESO	29943
COBRO PREJURIDICO - DEVOLUCION	5292
COBRO PREJURIDICO CARTERA K - INGRESO	3766
COBRO ADMINISTRATIVO DEVOLUCION	2465
COBRO ADMINISTRATIVO INGRESO	2412
Other values (16)	2195

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
COBRO PREJURIDICO - INGRESO	29943	61.1%
COBRO PREJURIDICO - DEVOLUCION	5292	10.8%
COBRO PREJURIDICO CARTERA K - INGRESO	3766	7.7%
COBRO ADMINISTRATIVO DEVOLUCION	2465	5.0%
COBRO ADMINISTRATIVO INGRESO	2412	4.9%
RETENCION SALARIAL-INGRESO	1426	2.9%
COBRO ADMINISTRATIVO CARTERA K -DEVOLUCION	215	0.4%
COBRO ADMINISTRATIVO CARTERA K - INGRESO	211	0.4%
RETENCION SALARIAL-DEVOLUCION	121	0.2%
COBRO PREJURIDICO CARTERA K - DEVOLUCION	108	0.2%
Other values (11)	114	0.2%
(Missing)	2909	5.9%

Frequencies of value counts

Unique

Unique	3 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	46
Median length	27
Mean length	27.02080356
Min length	3

SALDOCAPITALACIERRE
Real number (ℝ)

HIGH CORRELATION

Distinct	48004
Distinct (%)	98.7%
Missing	365
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%

Mean	7029252.595
Minimum	-2498131.23
Maximum	94723156
Zeros	175
Zeros (%)	0.4%
Memory size	382.7 KiB

Quantile statistics

Minimum	-2498131.23
5-th percentile	364692.828
Q1	2037374.15
median	4635403.81
Q3	9149828.36
95-th percentile	21775178.55
Maximum	94723156
Range	97221287.23
Interquartile range (IQR)	7112454.21

Descriptive statistics

Standard deviation	7814236.6
Coefficient of variation (CV)	1.111673893
Kurtosis	12.49686312
Mean	7029252.595
Median Absolute Deviation (MAD)	3092016.13
Skewness	2.811419267
Sum	3.417411734e+11
Variance	6.106229365e+13
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	175	0.4%
941040	23	< 0.1%
946508.75	8	< 0.1%
2852679	7	< 0.1%
2173494.5	7	< 0.1%
2696480.01	7	< 0.1%
2633333.17	7	< 0.1%
1247809.59	7	< 0.1%
939552	7	< 0.1%
2233447.98	7	< 0.1%
Other values (47994)	48362	98.7%
(Missing)	365	0.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-2498131.23	1	< 0.1%
-467789	1	< 0.1%
-383681	1	< 0.1%
-316679	1	< 0.1%
-233333.93	1	< 0.1%

Value	Count	Frequency (%)
94723156	1	< 0.1%
93503758.89	1	< 0.1%
88330116.58	1	< 0.1%
87882838	1	< 0.1%
86362867.72	1	< 0.1%

CAPITALICETEX_ACT
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	44386
Distinct (%)	91.2%
Missing	319
Missing (%)	0.7%
Infinite	0
Infinite (%)	0.0%

Mean	6734558.451
Minimum	-2498131.23
Maximum	94723155.76
Zeros	3863
Zeros (%)	7.9%
Memory size	382.7 KiB

Quantile statistics

Minimum	-2498131.23
5-th percentile	0
Q1	1642084.765
median	4384667
Q3	8933521.23
95-th percentile	21523460.92
Maximum	94723155.76
Range	97221286.99
Interquartile range (IQR)	7291436.465

Descriptive statistics

Standard deviation	7869618.489
Coefficient of variation (CV)	1.168542607
Kurtosis	12.21843224
Mean	6734558.451
Median Absolute Deviation (MAD)	3257906.2
Skewness	2.767087601
Sum	3.277238179e+11
Variance	6.193089516e+13
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3863	7.9%
941040	22	< 0.1%
946508.75	8	< 0.1%
2696480.01	7	< 0.1%
2852679	7	< 0.1%
939552	7	< 0.1%
2173494.5	7	< 0.1%
2633333.17	7	< 0.1%
1247809.59	7	< 0.1%
2233447.98	7	< 0.1%
Other values (44376)	44721	91.3%
(Missing)	319	0.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-2498131.23	1	< 0.1%
-2174006.96	1	< 0.1%
-681144.3	1	< 0.1%
-597070	1	< 0.1%
-590530.89	1	< 0.1%

Value	Count	Frequency (%)
94723155.76	1	< 0.1%
93503758.89	1	< 0.1%
88330116.58	1	< 0.1%
87882838.4	1	< 0.1%
86362867.72	1	< 0.1%

SUBLINEA
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct	74
Distinct (%)	0.2%
Missing	319
Missing (%)	0.7%
Memory size	382.7 KiB

ACCES	22816
ALIANZA	8001
PREGRADO MP	5112
CERES	2793
TU ELIGES 25%	2539
Other values (69)	7402

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
ACCES	22816	46.6%
ALIANZA	8001	16.3%
PREGRADO MP	5112	10.4%
CERES	2793	5.7%
TU ELIGES 25%	2539	5.2%
PREGRADO LARGO PLAZO	938	1.9%
POSGRADO PAIS CON DEUDOR	581	1.2%
PREGRADO MP 50-50	555	1.1%
TU ELIGES 50%	468	1.0%
POSGRADO PAIS SIN DEUDOR	450	0.9%
Other values (64)	4410	9.0%

Frequencies of value counts

Unique

Unique	8 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	49
Median length	5
Mean length	8.577518272
Min length	3

ESTRATO
Real number (ℝ_≥0)

MISSING

Distinct	7
Distinct (%)	< 0.1%
Missing	3002
Missing (%)	6.1%
Infinite	0
Infinite (%)	0.0%

Mean	1.845867769
Minimum	0
Maximum	6
Zeros	428
Zeros (%)	0.9%
Memory size	382.7 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	2
Q3	2
95-th percentile	3
Maximum	6
Range	6
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.8805006701
Coefficient of variation (CV)	0.4770117801
Kurtosis	1.378626055
Mean	1.845867769
Median Absolute Deviation (MAD)	1
Skewness	0.9315836994
Sum	84873
Variance	0.7752814301
Monotocity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
2	18571	37.9%
1	17718	36.2%
3	7617	15.6%
4	1177	2.4%
0	428	0.9%
5	360	0.7%
6	109	0.2%
(Missing)	3002	6.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	428	0.9%
1	17718	36.2%
2	18571	37.9%
3	7617	15.6%
4	1177	2.4%

Value	Count	Frequency (%)
6	109	0.2%
5	360	0.7%
4	1177	2.4%
3	7617	15.6%
2	18571	37.9%

SEXO
Categorical

MISSING

Distinct	2
Distinct (%)	< 0.1%
Missing	3123
Missing (%)	6.4%
Memory size	382.7 KiB

F	24180
M	21679

Frequencies
Length

Value	Count	Frequency (%)
F	24180	49.4%
M	21679	44.3%
(Missing)	3123	6.4%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.12751623
Min length	1

ESTADOCIVIL
Categorical

MISSING

Distinct	12
Distinct (%)	< 0.1%
Missing	2964
Missing (%)	6.1%
Memory size	382.7 KiB

SOLTERO(A)	37885
CASADO(A)	4000
OTRO	2350
1	803
UNIËN LIBRE	502
Other values (7)	478

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
SOLTERO(A)	37885	77.3%
CASADO(A)	4000	8.2%
OTRO	2350	4.8%
1	803	1.6%
UNIËN LIBRE	502	1.0%
DIVORCIADO(A) / SEPARADO(A)	271	0.6%
2	90	0.2%
UNIÓN LIBRE	47	0.1%
3	44	0.1%
VIUDO(A)	12	< 0.1%
Other values (2)	14	< 0.1%
(Missing)	2964	6.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	27
Median length	10
Mean length	9.136927851
Min length	1

TIPONOVEDAD
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	9
Missing (%)	< 0.1%
Memory size	382.7 KiB

N	37719
E	11253
M	1

Frequencies
Length

Value	Count	Frequency (%)
N	37719	77.0%
E	11253	23.0%
M	1	< 0.1%
(Missing)	9	< 0.1%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	3
Median length	1
Mean length	1.000367482
Min length	1

Rangodiasmora
Categorical

MISSING

Distinct	9
Distinct (%)	< 0.1%
Missing	12305
Missing (%)	25.1%
Memory size	382.7 KiB

(10) > 360	30331
(08) 181 - 270	1927
(09) 271 - 360	1341
(02) 1 - 30	916
(03) 31 - 60	719
Other values (4)	1443

Frequencies
Length

Value	Count	Frequency (%)
(10) > 360	30331	61.9%
(08) 181 - 270	1927	3.9%
(09) 271 - 360	1341	2.7%
(02) 1 - 30	916	1.9%
(03) 31 - 60	719	1.5%
(04) 61 - 90	568	1.2%
(06) 121 - 150	337	0.7%
(05) 91 - 120	328	0.7%
(07) 151 - 180	210	0.4%
(Missing)	12305	25.1%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	14
Median length	10
Mean length	8.644379568
Min length	3

CONCEPTO
Categorical

MISSING

Distinct	5
Distinct (%)	< 0.1%
Missing	14625
Missing (%)	29.9%
Memory size	382.7 KiB

MILLENNIALS	30900
GENERACIÓN X	2979
BABY BOOMERS	285
GENERACIÓN Z	192
GENERACIÓN SILENCIOSA	1

Frequencies
Length

Value	Count	Frequency (%)
MILLENNIALS	30900	63.1%
GENERACIÓN X	2979	6.1%
BABY BOOMERS	285	0.6%
GENERACIÓN Z	192	0.4%
GENERACIÓN SILENCIOSA	1	< 0.1%
(Missing)	14625	29.9%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	21
Median length	11
Mean length	8.682128129
Min length	3

FECHA_ACUERDO
Categorical

HIGH CARDINALITY
MISSING

Distinct	1423
Distinct (%)	4.2%
Missing	15306
Missing (%)	31.2%
Memory size	382.7 KiB

2017-06-30	195
2019-09-10	154
2016-07-12	154
2017-09-05	146
2019-08-05	142
Other values (1418)	32885

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2017-06-30	195	0.4%
2019-09-10	154	0.3%
2016-07-12	154	0.3%
2017-09-05	146	0.3%
2019-08-05	142	0.3%
2016-09-12	138	0.3%
2018-08-10	137	0.3%
2019-08-10	136	0.3%
2018-09-10	133	0.3%
2019-07-05	132	0.3%
Other values (1413)	32209	65.8%
(Missing)	15306	31.2%

Frequencies of value counts

Unique

Unique	85 ?
Unique (%)	0.3%

Histogram of lengths of the category

Length

Max length	10
Median length	10
Mean length	7.812625046
Min length	3

ESTADO_ACUERDO
Categorical

MISSING

Distinct	6
Distinct (%)	< 0.1%
Missing	15306
Missing (%)	31.2%
Memory size	382.7 KiB

INCUMPLIDO	14426
CUMPLIDO	14318
ANULADO	4683
APROBADO	229
APROBADO EXCEPC	19

Frequencies
Length

Value	Count	Frequency (%)
INCUMPLIDO	14426	29.5%
CUMPLIDO	14318	29.2%
ANULADO	4683	9.6%
APROBADO	229	0.5%
APROBADO EXCEPC	19	< 0.1%
O	1	< 0.1%
(Missing)	15306	31.2%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	15
Median length	8
Mean length	6.933587849
Min length	1

TIPO_ACUERDO
Categorical

MISSING

Distinct	7
Distinct (%)	< 0.1%
Missing	15306
Missing (%)	31.2%
Memory size	382.7 KiB

REFINANCIACION	13940
ABONO	6803
NORMALIZACION	6233
EXTINCION	4040
ABONOPV	2486
Other values (2)	174

Frequencies
Length

Value	Count	Frequency (%)
REFINANCIACION	13940	28.5%
ABONO	6803	13.9%
NORMALIZACION	6233	12.7%
EXTINCION	4040	8.2%
ABONOPV	2486	5.1%
ABONOPT	173	0.4%
AMORTIZACION	1	< 0.1%
(Missing)	15306	31.2%

Frequencies of value counts

Unique

Unique	1 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	14
Median length	7
Mean length	8.393021926
Min length	3

CUOTAS_PAGADAS_ACUERDO
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	34
Distinct (%)	0.1%
Missing	23473
Missing (%)	47.9%
Infinite	0
Infinite (%)	0.0%

Mean	0.7095142891
Minimum	0
Maximum	36
Zeros	14348
Zeros (%)	29.3%
Memory size	382.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	1
Maximum	36
Range	36
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	2.183946274
Coefficient of variation (CV)	3.078086387
Kurtosis	118.1374431
Mean	0.7095142891
Median Absolute Deviation (MAD)	0
Skewness	9.772485416
Sum	18099
Variance	4.76962133
Monotocity	Not monotonic

Histogram with fixed size bins (bins=34)

Value	Count	Frequency (%)
0	14348	29.3%
1	10127	20.7%
2	255	0.5%
3	160	0.3%
4	112	0.2%
6	76	0.2%
5	68	0.1%
7	47	0.1%
24	45	0.1%
9	35	0.1%
Other values (24)	236	0.5%
(Missing)	23473	47.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	14348	29.3%
1	10127	20.7%
2	255	0.5%
3	160	0.3%
4	112	0.2%

Value	Count	Frequency (%)
36	20	< 0.1%
35	1	< 0.1%
34	5	< 0.1%
33	2	< 0.1%
32	2	< 0.1%

CUOTAS_MORA_ACUERDO
Real number (ℝ_≥0)

MISSING
ZEROS

Distinct	43
Distinct (%)	0.2%
Missing	23473
Missing (%)	47.9%
Infinite	0
Infinite (%)	0.0%

Mean	1.556940688
Minimum	0
Maximum	47
Zeros	12558
Zeros (%)	25.6%
Memory size	382.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	1
95-th percentile	9
Maximum	47
Range	47
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	4.456137809
Coefficient of variation (CV)	2.862111476
Kurtosis	25.81324986
Mean	1.556940688
Median Absolute Deviation (MAD)	1
Skewness	4.848328713
Sum	39716
Variance	19.85716417
Monotocity	Not monotonic

Histogram with fixed size bins (bins=43)

Value	Count	Frequency (%)
0	12558	25.6%
1	10421	21.3%
2	436	0.9%
3	230	0.5%
12	178	0.4%
24	165	0.3%
6	165	0.3%
18	138	0.3%
5	136	0.3%
4	123	0.3%
Other values (33)	959	2.0%
(Missing)	23473	47.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	12558	25.6%
1	10421	21.3%
2	436	0.9%
3	230	0.5%
4	123	0.3%

Value	Count	Frequency (%)
47	1	< 0.1%
42	2	< 0.1%
41	3	< 0.1%
40	1	< 0.1%
39	2	< 0.1%

CUOTAS_FUTURAS_ACUERDO
Real number (ℝ_≥0)

MISSING
SKEWED
ZEROS

Distinct	60
Distinct (%)	0.2%
Missing	23473
Missing (%)	47.9%
Infinite	0
Infinite (%)	0.0%

Mean	0.2872319573
Minimum	0
Maximum	173
Zeros	25087
Zeros (%)	51.2%
Memory size	382.7 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	173
Range	173
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	4.572231656
Coefficient of variation (CV)	15.9182554
Kurtosis	527.0918458
Mean	0.2872319573
Median Absolute Deviation (MAD)	0
Skewness	21.17064286
Sum	7327
Variance	20.90530231
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	25087	51.2%
1	269	0.5%
55	12	< 0.1%
36	11	< 0.1%
2	11	< 0.1%
3	9	< 0.1%
35	7	< 0.1%
4	7	< 0.1%
54	5	< 0.1%
42	4	< 0.1%
Other values (50)	87	0.2%
(Missing)	23473	47.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	25087	51.2%
1	269	0.5%
2	11	< 0.1%
3	9	< 0.1%
4	7	< 0.1%

Value	Count	Frequency (%)
173	1	< 0.1%
155	1	< 0.1%
145	1	< 0.1%
138	1	< 0.1%
135	2	< 0.1%

fecha Venc Cuota Vigente
Categorical

HIGH CARDINALITY
MISSING

Distinct	103
Distinct (%)	0.7%
Missing	33410
Missing (%)	68.2%
Memory size	382.7 KiB

2020-02-20	5441
2020-05-02	4913
2020-02-17	2329
2020-10-02	1394
2020-03-02	234
Other values (98)	1261

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2020-02-20	5441	11.1%
2020-05-02	4913	10.0%
2020-02-17	2329	4.8%
2020-10-02	1394	2.8%
2020-03-02	234	0.5%
2020-01-28	227	0.5%
2020-01-30	165	0.3%
2020-01-31	89	0.2%
2020-05-03	79	0.2%
2020-03-20	66	0.1%
Other values (93)	635	1.3%
(Missing)	33410	68.2%

Frequencies of value counts

Unique

Unique	47 ?
Unique (%)	0.3%

Histogram of lengths of the category

Length

Max length	10
Median length	3
Mean length	5.225388918
Min length	3

Valor Cuota Vigente
Categorical

HIGH CARDINALITY
MISSING

Distinct	6843
Distinct (%)	20.3%
Missing	15306
Missing (%)	31.2%
Memory size	382.7 KiB

0	26746
335106	3
599851	3
116905	3
52930	3
Other values (6838)	6918

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
0	26746	54.6%
335106	3	< 0.1%
599851	3	< 0.1%
116905	3	< 0.1%
52930	3	< 0.1%
160354,16	3	< 0.1%
56537	2	< 0.1%
104743	2	< 0.1%
53031	2	< 0.1%
138921	2	< 0.1%
Other values (6833)	6907	14.1%
(Missing)	15306	31.2%

Frequencies of value counts

Unique

Unique	6759 ?
Unique (%)	20.1%

Histogram of lengths of the category

Length

Max length	9
Median length	1
Mean length	2.306704504
Min length	1

No. ACUERDOS DE PAGO
Real number (ℝ_≥0)

MISSING

Distinct	32
Distinct (%)	0.1%
Missing	15306
Missing (%)	31.2%
Infinite	0
Infinite (%)	0.0%

Mean	3.434047987
Minimum	1
Maximum	46
Zeros	0
Zeros (%)	0.0%
Memory size	382.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	3
Q3	5
95-th percentile	9
Maximum	46
Range	45
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.860770791
Coefficient of variation (CV)	0.8330608082
Kurtosis	9.723459991
Mean	3.434047987
Median Absolute Deviation (MAD)	2
Skewness	2.299368377
Sum	115645
Variance	8.18400952
Monotocity	Not monotonic

Histogram with fixed size bins (bins=32)

Value	Count	Frequency (%)
1	9464	19.3%
2	6852	14.0%
3	5132	10.5%
4	3711	7.6%
5	2662	5.4%
6	1835	3.7%
7	1221	2.5%
8	865	1.8%
9	578	1.2%
10	377	0.8%
Other values (22)	979	2.0%
(Missing)	15306	31.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	9464	19.3%
2	6852	14.0%
3	5132	10.5%
4	3711	7.6%
5	2662	5.4%

Value	Count	Frequency (%)
46	1	< 0.1%
39	1	< 0.1%
31	2	< 0.1%
30	1	< 0.1%
29	3	< 0.1%

RazonSocial
Categorical

HIGH CARDINALITY
MISSING

Distinct	19241
Distinct (%)	61.9%
Missing	17908
Missing (%)	36.6%
Memory size	382.7 KiB

CORPORACION UNIVERSITARIA DEL CARIBE, CECAR.	198
REGISTRADURIA NACIONAL DEL ESTADO CIVIL	186
COMFENALCO	142
UNIVERSIDAD COOPERATIVA DE COLOMBIA	140
UNIVERSIDAD SIMON BOLIVAR	135
Other values (19236)	30273

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
CORPORACION UNIVERSITARIA DEL CARIBE, CECAR.	198	0.4%
REGISTRADURIA NACIONAL DEL ESTADO CIVIL	186	0.4%
COMFENALCO	142	0.3%
UNIVERSIDAD COOPERATIVA DE COLOMBIA	140	0.3%
UNIVERSIDAD SIMON BOLIVAR	135	0.3%
S E N A	131	0.3%
ACTIVOS SAS	115	0.2%
TELEPERFORMANCE COLOMBIA S A S	107	0.2%
ALMACENES EXITO S A	106	0.2%
CAJA COLOMBIANA DE SUBSIDIO FAMILIAR COLSUBSI	100	0.2%
Other values (19231)	29714	60.7%
(Missing)	17908	36.6%

Frequencies of value counts

Unique

Unique	16550 ?
Unique (%)	53.3%

Histogram of lengths of the category

Length

Max length	180
Median length	18
Mean length	18.47701196
Min length	3

UltimoPeriodoCotizado
Categorical

HIGH CARDINALITY
MISSING

Distinct	174
Distinct (%)	0.5%
Missing	14172
Missing (%)	28.9%
Memory size	382.7 KiB

2020-10	8670
2020-09	4482
1900-01	3736
2020-08	1487
2019-12	747
Other values (169)	15688

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
2020-10	8670	17.7%
2020-09	4482	9.2%
1900-01	3736	7.6%
2020-08	1487	3.0%
2019-12	747	1.5%
2019-11	670	1.4%
2020-07	633	1.3%
2020-01	632	1.3%
2020-04	630	1.3%
2020-06	541	1.1%
Other values (164)	12582	25.7%
(Missing)	14172	28.9%

Frequencies of value counts

Unique

Unique	8 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	7
Median length	7
Mean length	5.842676902
Min length	3

FechaFosyga
Categorical

MISSING

Distinct	1
Distinct (%)	< 0.1%
Missing	14172
Missing (%)	28.9%
Memory size	382.7 KiB

2020-10-01	34810

Frequencies
Length

Value	Count	Frequency (%)
2020-10-01	34810	71.1%
(Missing)	14172	28.9%

Frequencies of value counts

Unique

Unique	0 ?
Unique (%)	0.0%

Histogram of lengths of the category

Length

Max length	10
Median length	10
Mean length	7.974684578
Min length	3

Hora_ContactoEfectivo
Real number (ℝ_≥0)

MISSING

Distinct	14
Distinct (%)	< 0.1%
Missing	20802
Missing (%)	42.5%
Infinite	0
Infinite (%)	0.0%

Mean	11.10809084
Minimum	7
Maximum	20
Zeros	0
Zeros (%)	0.0%
Memory size	382.7 KiB

Quantile statistics

Minimum	7
5-th percentile	8
Q1	9
median	11
Q3	13
95-th percentile	16
Maximum	20
Range	13
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	2.80992772
Coefficient of variation (CV)	0.252962256
Kurtosis	-0.3780261183
Mean	11.10809084
Median Absolute Deviation (MAD)	2
Skewness	0.6365925316
Sum	313026
Variance	7.895693789
Monotocity	Not monotonic

Histogram with fixed size bins (bins=14)

Value	Count	Frequency (%)
9	4595	9.4%
8	4278	8.7%
10	3748	7.7%
11	3217	6.6%
12	2711	5.5%
13	2219	4.5%
15	1913	3.9%
14	1866	3.8%
7	1302	2.7%
16	1230	2.5%
Other values (4)	1101	2.2%
(Missing)	20802	42.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
7	1302	2.7%
8	4278	8.7%
9	4595	9.4%
10	3748	7.7%
11	3217	6.6%

Value	Count	Frequency (%)
20	21	< 0.1%
19	268	0.5%
18	272	0.6%
17	540	1.1%
16	1230	2.5%

Llamadas_recibidas
Real number (ℝ_≥0)

MISSING

Distinct	38
Distinct (%)	0.1%
Missing	11236
Missing (%)	22.9%
Infinite	0
Infinite (%)	0.0%

Mean	4.026439888
Minimum	1
Maximum	48
Zeros	0
Zeros (%)	0.0%
Memory size	382.7 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	5
95-th percentile	10
Maximum	48
Range	47
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	3.179379569
Coefficient of variation (CV)	0.7896254899
Kurtosis	7.900779322
Mean	4.026439888
Median Absolute Deviation (MAD)	2
Skewness	1.999249804
Sum	151982
Variance	10.10845444
Monotocity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
1	8108	16.6%
2	6831	13.9%
3	5703	11.6%
4	4494	9.2%
5	3466	7.1%
6	2538	5.2%
7	1873	3.8%
8	1452	3.0%
9	940	1.9%
10	686	1.4%
Other values (28)	1655	3.4%
(Missing)	11236	22.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	8108	16.6%
2	6831	13.9%
3	5703	11.6%
4	4494	9.2%
5	3466	7.1%

Value	Count	Frequency (%)
48	1	< 0.1%
43	1	< 0.1%
41	1	< 0.1%
36	1	< 0.1%
34	2	< 0.1%

Llamadas_realizadas
Real number (ℝ_≥0)

MISSING

Distinct	99
Distinct (%)	0.2%
Missing	3240
Missing (%)	6.6%
Infinite	0
Infinite (%)	0.0%

Mean	15.02476936
Minimum	1
Maximum	164
Zeros	0
Zeros (%)	0.0%
Memory size	382.7 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	6
median	12
Q3	21
95-th percentile	38
Maximum	164
Range	163
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	11.99213699
Coefficient of variation (CV)	0.7981578086
Kurtosis	3.429694931
Mean	15.02476936
Median Absolute Deviation (MAD)	7
Skewness	1.425010291
Sum	687263
Variance	143.8113495
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2175	4.4%
4	2148	4.4%
3	2138	4.4%
2	2093	4.3%
5	2080	4.2%
7	2048	4.2%
6	2042	4.2%
8	1947	4.0%
9	1833	3.7%
10	1765	3.6%
Other values (89)	25473	52.0%
(Missing)	3240	6.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	2175	4.4%
2	2093	4.3%
3	2138	4.4%
4	2148	4.4%
5	2080	4.2%

Value	Count	Frequency (%)
164	1	< 0.1%
133	1	< 0.1%
132	1	< 0.1%
118	1	< 0.1%
116	1	< 0.1%

Tipificacion
Categorical

HIGH CARDINALITY
MISSING

Distinct	92
Distinct (%)	0.2%
Missing	2524
Missing (%)	5.2%
Memory size	382.7 KiB

NO EFECTIVO_NO LO CONOCEN_NAN_NAN	9923
NO CONTACTADO_NO CONTESTA_NAN_NAN	7730
NO CONTACTADO_BUZON_NAN_NAN	5738
NO EFECTIVO_MENSAJE CON TERCERO_NAN_NAN	3468
EFECTIVO_COMPROMISO DE PAGO_NAN_NAN	1762
Other values (87)	17837

Frequencies
Length

Common Values
Overview

Value	Count	Frequency (%)
NO EFECTIVO_NO LO CONOCEN_NAN_NAN	9923	20.3%
NO CONTACTADO_NO CONTESTA_NAN_NAN	7730	15.8%
NO CONTACTADO_BUZON_NAN_NAN	5738	11.7%
NO EFECTIVO_MENSAJE CON TERCERO_NAN_NAN	3468	7.1%
EFECTIVO_COMPROMISO DE PAGO_NAN_NAN	1762	3.6%
OTROS_CAIDA_NAN_NAN	1751	3.6%
EFECTIVO_NO REALIZA PAGO_RENUENTE_NAN	1702	3.5%
EFECTIVO_NO REALIZA PAGO_INSOLVENTE_NAN	1633	3.3%
EFECTIVO_CR DITO ADMINISTRATIVO_NAN_NAN	1193	2.4%
EFECTIVO_PROGRAMACI N DE LLAMADA_NAN_NAN	1122	2.3%
Other values (82)	10436	21.3%
(Missing)	2524	5.2%

Frequencies of value counts

Unique

Unique	12 ?
Unique (%)	< 0.1%

Histogram of lengths of the category

Length

Max length	81
Median length	33
Mean length	33.85143522
Min length	3

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

First rows

	IDSOLICITUD	FECHAENTRADA	FECHASALIDA	FECHAACTUALIZACION	FECHAMORADESDE	NROCUOTASMORA	NUMDIASMORA_ACT	VALORCUOTA	SALDOTOTALMORA1_ACT	SALDOTOTAL_ACT	FECHAMOVIMIENTO	CALIFICACIONACTUAL	VCTO_CUOTA1	FECHA_VCTO	FECHAULTPAGO	SALDOINICIAAMORT	DEPTORESIDENCIA	MUNICRESIDENCIA	CODSNIES_INST	IES	NOMBREPROGRAMA	NIVELDEFORMACION	LINEA	TIPOCARTERA	ESTADOACTUAL	SALDOCAPITALACIERRE	CAPITALICETEX_ACT	SUBLINEA	ESTRATO	SEXO	ESTADOCIVIL	TIPONOVEDAD	Rangodiasmora	CONCEPTO	FECHA_ACUERDO	ESTADO_ACUERDO	TIPO_ACUERDO	CUOTAS_PAGADAS_ACUERDO	CUOTAS_MORA_ACUERDO	CUOTAS_FUTURAS_ACUERDO	fecha Venc Cuota Vigente	Valor Cuota Vigente	No. ACUERDOS DE PAGO	RazonSocial	UltimoPeriodoCotizado	FechaFosyga	Hora_ContactoEfectivo	Llamadas_recibidas	Llamadas_realizadas	Tipificacion
0	280	2020-11-17	NaN	2020-11-17	NaN	0.0	6.0	218384.59	231102.87	4248178.84	2020-11-17	K	2010-01-31	2022-06-10	2020-10-15	27788677.09	VALLE DEL CAUCA	ZARZAL	1834.0	UNIVERSIDAD DEL SINU Elias Bechara Zainum - UNISIN	MEDICINA	UNIVERSITARIA	ACCES	AMORTIZACION	COBRO ADMINISTRATIVO DEVOLUCION	4001850.62	4001850.62	ACCES	1.0	F	SOLTERO(A)	N	NaN	NaN	2017-09-22	INCUMPLIDO	NORMALIZACION	0.0	1.0	0.0	2020-10-02	287094	3.0	NaN	NaN	NaN	NaN	1.0	1.0	NO CONTACTADO_BUZON_NAN_NAN
1	372	2020-11-10	2020-11-17	2020-11-17	NaN	0.0	0.0	145209.36	0.00	11004369.72	2020-11-17	K	2018-12-03	2026-08-03	2020-10-10	15310906.24	DISTRITO CAPITAL	BOGOTA D.C.	2825.0	CORPORACION UNIVERSITARIA RAFAEL NUNEZ	BACTERIOLOGIA	UNIVERSITARIA	ACCES	AMORTIZACION	COBRO ADMINISTRATIVO DEVOLUCION	9102814.62	8985988.33	ACCES	1.0	F	SOLTERO(A)	E	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	9.0	EFECTIVO_REALIZA ACUERDO DE PAGO_ABONO PAGO VENCIDO_NAN
2	1132	2020-11-10	2020-11-17	2020-11-17	NaN	0.0	11.0	167036.95	269.36	6514205.03	2020-11-17	K	2011-07-02	2024-04-05	2020-10-02	19772924.31	VALLE DEL CAUCA	CALI	1805.0	UNIVERSIDAD SANTIAGO DE CALI	DERECHO	UNIVERSITARIA	ACCES	AMORTIZACION	COBRO PREJURIDICO - INGRESO	6566208.21	6422071.95	ACCES	2.0	F	SOLTERO(A)	E	NaN	NaN	2019-05-08	INCUMPLIDO	ABONO	0.0	1.0	0.0	2020-02-20	0	8.0	NaN	NaN	NaN	7.0	10.0	30.0	EFECTIVO_YA PAGO_PENDIENTE CONDONACI N_NAN
3	3518	2020-11-01	2020-11-17	2020-11-17	2020-03-05	7.0	0.0	186526.37	0.00	1187551.21	2020-11-17	K	2009-11-30	2020-10-05	2020-09-29	9226473.98	CUNDINAMARCA	NEMOCON	1729.0	UNIVERSIDAD EL BOSQUE	LICENCIATURA EN PEDAGOGIA INFANTIL	UNIVERSITARIA	ACCES	AMORTIZACION	COBRO PREJURIDICO - INGRESO	1367000.12	1084521.26	ACCES	2.0	F	SOLTERO(A)	E	NaN	NaN	2020-08-28	CUMPLIDO	REFINANCIACION	NaN	NaN	NaN	NaN	0	6.0	NaN	NaN	NaN	10.0	12.0	25.0	EFECTIVO_CR DITOS NO ASIGNADOS_INFORMACI N GENERAL_NAN
4	5648	2020-11-17	NaN	2020-11-17	2020-10-10	1.0	6.0	331863.91	223180.79	2155653.88	2020-11-17	K	2010-09-30	2021-05-10	2020-10-02	28772345.48	DISTRITO CAPITAL	BOGOTA D.C.	1701.0	PONTIFICIA UNIVERSIDAD JAVERIANA	ARTES VISUALES	UNIVERSITARIA	ACCES	AMORTIZACION	COBRO ADMINISTRATIVO INGRESO	2351493.36	1974883.40	ACCES	3.0	F	SOLTERO(A)	N	(02) 1 - 30	MILLENNIALS	2017-04-29	CUMPLIDO	ABONO	1.0	0.0	0.0	2020-10-02	0	2.0	INDRA COLOMBIA S A S	2020-10	2020-10-01	NaN	NaN	NaN	NaN
5	11611	2020-11-01	2020-11-17	2020-11-17	2020-07-20	3.0	0.0	242481.68	0.00	3496093.91	2020-11-17	K	2010-01-31	2021-09-20	2020-10-24	13308548.27	DISTRITO CAPITAL	BOGOTA D.C.	2830.0	CORPORACION UNIVERSITARIA IBEROAMERICANA	FISIOTERAPIA	UNIVERSITARIA	ACCES	AMORTIZACION	COBRO PREJURIDICO - INGRESO	3548961.23	3476670.71	ACCES	2.0	F	OTRO	E	NaN	NaN	2017-10-23	CUMPLIDO	ABONO	1.0	0.0	0.0	2020-02-20	0	7.0	NaN	NaN	NaN	8.0	6.0	11.0	EFECTIVO_REALIZA ACUERDO DE PAGO_REFINANCIACI N_NAN
6	19061	2020-11-17	NaN	2020-11-17	NaN	0.0	6.0	76974.93	101598.30	1301706.74	2020-11-17	K	2009-06-23	2021-11-10	2020-10-15	6658620.73	DISTRITO CAPITAL	BOGOTA D.C.	1704.0	UNIVERSIDAD SANTO TOMAS	CULTURA FISICA, DEPORTE Y RECREACION	UNIVERSITARIA	ACCES	AMORTIZACION	COBRO ADMINISTRATIVO INGRESO	981064.89	981064.89	ACCES	2.0	M	OTRO	N	(02) 1 - 30	NaN	2020-09-29	CUMPLIDO	NORMALIZACION	NaN	NaN	NaN	NaN	0	2.0	SOCIEDAD CLINICA CASANARE LTDA	2020-10	2020-10-01	NaN	1.0	4.0	NO CONTACTADO_BUZON_NAN_NAN
7	29708	2020-11-17	NaN	2020-11-17	NaN	0.0	6.0	242749.81	271990.92	9713836.58	2020-11-17	K	2009-12-06	2023-10-10	2020-10-26	32486333.69	ATLANTICO	BARRANQUILLA	1824.0	UNIVERSIDAD METROPOLITANA	MEDICINA	UNIVERSITARIA	ACCES	AMORTIZACION	COBRO ADMINISTRATIVO DEVOLUCION	8187188.16	8187188.16	ACCES	2.0	M	OTRO	N	(02) 1 - 30	NaN	2016-04-28	INCUMPLIDO	NORMALIZACION	2.0	34.0	0.0	2020-10-02	343297	3.0	DAVITA S.A.S.	2020-10	2020-10-01	9.0	1.0	7.0	EFECTIVO_NO REALIZA PAGO_RECLAMACI N_NAN
8	43222	2020-11-01	2020-11-17	2020-11-17	2019-06-10	16.0	0.0	127736.53	0.00	2436116.54	2020-11-17	K	2009-06-30	2021-05-10	2019-08-28	10630503.06	MAGDALENA	FUNDACION	1804.0	PA FIDUPREVISORAS A UNIVERSIDAD AUTONOMA DEL CARIBE	ADMINISTRACION DE EMPRESAS	UNIVERSITARIA	ACCES	AMORTIZACION	COBRO PREJURIDICO - INGRESO	2943496.62	2435104.62	ACCES	1.0	F	OTRO	E	NaN	NaN	2020-09-11	CUMPLIDO	REFINANCIACION	NaN	NaN	NaN	NaN	0	2.0	NaN	NaN	NaN	13.0	5.0	7.0	EFECTIVO_REALIZA ACUERDO DE PAGO_REFINANCIACION_GENERAL
9	46319	2020-11-01	2020-11-17	2020-11-17	2020-03-20	6.0	0.0	113099.77	0.00	531835.54	2020-11-17	K	2019-04-20	2020-09-20	2020-02-13	6175296.15	BOLIVAR	CARTAGENA	2833.0	CORPORACION UNIVERSITARIA REMINGTON	CONTADURIA PUBLICA	UNIVERSITARIA	ACCES	AMORTIZACION	COBRO PREJURIDICO - INGRESO	781666.81	530666.81	ACCES	2.0	M	SOLTERO(A)	E	NaN	NaN	2019-03-15	CUMPLIDO	REFINANCIACION	1.0	0.0	0.0	2020-02-20	0	2.0	NaN	NaN	NaN	8.0	6.0	5.0	EFECTIVO_REALIZA ACUERDO DE PAGO_REFINANCIACION_GENERAL

Last rows

	IDSOLICITUD	FECHAENTRADA	FECHASALIDA	FECHAACTUALIZACION	FECHAMORADESDE	NROCUOTASMORA	NUMDIASMORA_ACT	VALORCUOTA	SALDOTOTALMORA1_ACT	SALDOTOTAL_ACT	FECHAMOVIMIENTO	CALIFICACIONACTUAL	VCTO_CUOTA1	FECHA_VCTO	FECHAULTPAGO	SALDOINICIAAMORT	DEPTORESIDENCIA	MUNICRESIDENCIA	CODSNIES_INST	IES	NOMBREPROGRAMA	NIVELDEFORMACION	LINEA	TIPOCARTERA	ESTADOACTUAL	SALDOCAPITALACIERRE	CAPITALICETEX_ACT	SUBLINEA	ESTRATO	SEXO	ESTADOCIVIL	TIPONOVEDAD	Rangodiasmora	CONCEPTO	FECHA_ACUERDO	ESTADO_ACUERDO	TIPO_ACUERDO	CUOTAS_PAGADAS_ACUERDO	CUOTAS_MORA_ACUERDO	CUOTAS_FUTURAS_ACUERDO	fecha Venc Cuota Vigente	Valor Cuota Vigente	No. ACUERDOS DE PAGO	RazonSocial	UltimoPeriodoCotizado	FechaFosyga	Hora_ContactoEfectivo	Llamadas_recibidas	Llamadas_realizadas	Tipificacion
48972	104853	2018-11-01	2019-11-12	2018-11-01	2016-04-28	30.0	916.0	610970.0	22391877.00	45768569.33	2018-11-01	K	2011-04-28	2022-03-28	2016-03-29	62842638.83	VALLE DEL CAUCA	CALI	1805.0	UNIVERSIDAD SANTIAGO DE CALI	MEDICINA	UNIVERSITARIA	ACCES	AMORTIZACION	NaN	38377782.38	25585187.65	ACCES	2.0	F	1	N	NaN	NaN	2017-05-04	INCUMPLIDO	ABONO	0.0	1.0	0.0	2020-01-28	0	2.0	NaN	NaN	NaN	9.0	NaN	5.0	NO CONTACTADO_BUZON_NAN_NAN
48973	260045	2018-11-01	2019-11-12	2018-11-01	2018-05-15	5.0	169.0	237421.0	1457170.00	15717086.60	2018-11-01	K	2017-04-15	2024-03-15	2018-04-07	11485602.70	PUTUMAYO	MOCOA	3115.0	INSTITUTO TECNOLOGICO DEL PUTUMAYO MOCOA	INGENIERIA DE SISTEMAS	UNIVERSITARIA	ACCES	AMORTIZACION	NaN	11248350.86	11248350.86	ACCES	1.0	M	1	N	(08) 181 - 270	MILLENNIALS	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	SECRETARIA DE EDUCACION DEPARTAMENTAL DE PUTUMAYO	2020-01	2020-10-01	NaN	NaN	NaN	NaN
48974	260411	2018-11-01	2019-11-12	2018-11-01	2017-10-03	12.0	362.0	153471.0	2105091.00	2411649.36	2018-11-01	K	2009-12-06	2018-12-03	2017-11-29	6137108.41	BOLIVAR	CARTAGENA	1701.0	PONTIFICIA UNIVERSIDAD JAVERIANA	LICENCIATURA EN LENGUAS MODERNAS	UNIVERSITARIA	ACCES	AMORTIZACION	NaN	1435555.80	1435555.80	ACCES	2.0	F	1	N	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	12.0	NaN	2.0	EFECTIVO_COMPROMISO DE PAGO_NAN_NAN
48975	434529	2018-11-01	2019-11-12	2018-11-01	2017-01-20	12.0	649.0	368257.0	4938139.38	4938139.38	2018-11-01	K	2017-01-20	2017-12-20	NaN	2552662.95	NARINO	PASTO	1720.0	UNIVERSIDAD MARIANA	TERAPIA OCUPACIONAL	UNIVERSITARIA	LINEAS TRADICIONALES	AMORTIZACION	NaN	2552662.96	2552662.96	PREGRADO MP	2.0	F	1	N	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
48976	444162	2018-11-01	2019-11-12	2018-11-01	2017-01-20	6.0	649.0	328425.0	2450343.45	2450343.45	2018-11-01	K	2017-01-20	2017-06-20	2016-04-20	1933333.34	ANTIOQUIA	ENVIGADO	1812.0	UNIVERSIDAD DE MEDELLIN	COMUNICACION Y LENGUAJES AUDIOVISUALES	UNIVERSITARIA	LINEAS TRADICIONALES	AMORTIZACION	NaN	1933333.34	1933333.34	PREGRADO MP	3.0	M	1	N	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN
48977	1214479	2018-11-01	2019-11-12	2018-11-01	2018-04-10	6.0	174.0	204986.0	1316691.00	7749086.22	2018-11-01	K	2009-07-31	2021-07-10	2018-06-26	18345094.11	DISTRITO CAPITAL	BOGOTA D.C.	1725.0	FUNDACION UNIVERSIDAD AUTONOMA DE COLOMBIA -FUAC-	DERECHO	UNIVERSITARIA	LINEAS TRADICIONALES	AMORTIZACION	NaN	7022591.75	7022591.75	PREGRADO LARGO PLAZO	NaN	F	3	N	NaN	NaN	2017-06-30	CUMPLIDO	REFINANCIACION	1.0	0.0	0.0	2020-10-02	0	1.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN
48978	1522420	2018-11-01	2019-11-12	2018-11-01	2015-07-17	39.0	1202.0	132792.0	6704498.00	12144201.59	2018-11-01	K	2015-07-17	2022-06-17	2013-10-31	11261527.31	VALLE DEL CAUCA	RIOFRIO	2301.0	UNIDAD CENTRAL DEL VALLE DEL CAUCA	DERECHO	UNIVERSITARIA	ACCES	AMORTIZACION	NaN	9180833.59	9180833.59	ACCES	1.0	M	1	N	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	NaN	1.0	NO EFECTIVO_NO LO CONOCEN_NAN_NAN
48979	1731356	2018-11-01	2019-11-12	2018-11-01	2015-09-17	13.0	1140.0	72108.0	1341981.59	1341981.59	2018-11-01	K	2014-10-17	2016-09-17	2015-07-27	1800940.99	SANTANDER	GIRON	3201.0	UNIDADES TECNOLOGICAS DE SANTANDER	TECNOLOGIA EN OPERACION Y MANTENIMIENTO ELECTROMECANICO	TECNOLOGICA TERMINAL	ACCES	AMORTIZACION	NaN	920079.12	920079.12	ACCES	1.0	M	1	N	NaN	NaN	2017-10-25	INCUMPLIDO	REFINANCIACION	0.0	1.0	0.0	NaN	0	4.0	NaN	NaN	NaN	NaN	NaN	NaN	NaN
48980	1733481	2018-11-01	2019-11-12	2018-11-01	2015-12-17	34.0	1049.0	84446.0	3479513.00	6341023.00	2018-11-01	K	2015-12-17	2021-11-17	2014-06-24	6196785.00	DISTRITO CAPITAL	BOGOTA D.C.	4832.0	CORPORACION INSTITUTO SUPERIOR DE EDUCACION SOCIAL	TECNICA PROFESIONAL EN DISENO GRAFICO	TECNICA PROFESIONAL	ACCES	AMORTIZACION	NaN	4863852.46	4863852.46	ACCES	2.0	M	1	N	NaN	NaN	2020-02-20	CUMPLIDO	REFINANCIACION	NaN	NaN	NaN	NaN	0	2.0	NaN	NaN	NaN	NaN	2.0	3.0	EFECTIVO_CR DITO ADMINISTRATIVO_NAN_NAN
48981	2445369	2018-11-01	2019-11-12	2018-11-01	2016-01-20	6.0	984.0	326242.0	2337663.05	2337663.05	2018-11-01	K	2016-01-20	2016-06-20	2017-02-15	1937064.95	DISTRITO CAPITAL	BOGOTA D.C.	1709.0	FUNDACION UNIVERSIDAD CENTRAL	PUBLICIDAD	UNIVERSITARIA	LINEAS TRADICIONALES	AMORTIZACION	NaN	1632905.14	1632905.14	PREGRADO MP	2.0	F	1	N	NaN	NaN	2017-06-17	INCUMPLIDO	REFINANCIACION	0.0	1.0	0.0	NaN	0	4.0	NaN	NaN	NaN	NaN	NaN	1.0	NO EFECTIVO_NO LO CONOCEN_NAN_NAN

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows